Help with a formula

Solved/Closed
Report
Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015
-
Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015
-
Please help !!
Looking to calculate totals based on the following...

Entering the formula in the following field K4

I have rows (B4 thru B18) each has a seperate text (registration, raffle, swag, etc)
in those same rows I have a total coloum with a value paid (h4 thru h18). what i am trying to do is summarize in (k4) all the total dollars collected by each catagory

so basically K4 would be total registration money collect ( i want to sum up all rows h4-h18 that have "registration" listed in coloum B

1 reply

you can do this using the sumif function:

=SUMIF(B4:B18,"registration",H4:H18)
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015

that worked thanks so much !!! sorry if that seemed like a stupid question but i am still learning the program
much appreciated!