Need help with formula

K

Kheckent

I am trying to build a formula that will find all instances of a
particular word in one in column then add the corresponding number that
is in another column for a total of that particular word.

ie: column A column B
sp 4.00
hol 4.00
sp 8.00
vac 6.00

I want to total all instances of "sp"

Thanks for the help
 
Z

Zakir Ulla

Hi,

Try the countif function to count the instances of the word you are looking
for..

=COUNTIF(range,criteria), put the criteria as follows "SP"....

regards,
Zakir Ulla
 
N

Norman Harker

Hi Kheckent!

With your data in A1:B4:

One way:

=SUMIF($A$1:$A$4,"sp",$B$1:$B$4)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top