Another sumif question:

[Mel B]

In a campground operation with respect to reconcilliation I need to sum receipts catagorized by "C" or "CK" from a drop down box.

The sheet looks like this:

R S T U V W X Y

Dump C Day C C Season C
Fee CK Use CK Wood CK Pass CK

$15.00 C $5.00 CK $6.00 C $50.00 CK

Each column is 21 cells deep. I would like to sum the total revenue in R, T, V and X and then in a seperate 2 cells sum the "Total Cash" and the "Total Checks" from the 4 columns.

Thanks,

Mel

[Pete_UK]

What are your other categories of payment? Do any of them begin with C (like Card or Cash) ?

If not, then you can use wildcard characters with SUMIF, so your criterion could be "C*".

Hope this helps.

Pete