Previous Topic Next Topic

Help with a formula

Solved/Closed
hockeymom Posts 2 Registration date Tuesday December 8, 2015 Status Member Last seen December 8, 2015 - Dec 8, 2015 at 01:19 PM
hockeymom Posts 2 Registration date Tuesday December 8, 2015 Status Member Last seen December 8, 2015 - Dec 8, 2015 at 01:38 PM
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

Answer 1 / 1
rayh
Dec 8, 2015 at 01:31 PM
you can do this using the sumif function:

=SUMIF(B4:B18,"registration",H4:H18)
1
hockeymom Posts 2 Registration date Tuesday December 8, 2015 Status Member Last seen December 8, 2015
Dec 8, 2015 at 01:38 PM
that worked thanks so much !!! sorry if that seemed like a stupid question but i am still learning the program
much appreciated!
0