I am sorry to post again in another thread, I'm still getting used to the forum!
I had a question about SUMIF, SUMIFS and SUMPRODUCT.
Well, I could manage to work with SUMIFS, but now I have an urgent need to adapt it to OO, so I need SUMPRODUCT.
I attached an Example of my DataSheet. It has SALES and the BREAKDOWN, where I basically put together a daily report!
As you can see, on the BREAKDOWN Sheet I want to SUMIF the values of the SALES, but under the FORM OF PAYMENT criteria. I can do it easily with SUIMIF, but when I go to the next day e.g. 10/10/10 I have to use SUMIF again and manually declare the range of rows I want to include in the formula, and that really sux! I want to say WHEN ANY cells from the Column A from SALES matches the value of A2 (05/05/05 in the example), then SUMIF(RANGE 1;"CREDIT";RANGE 2), the regular SUMIF! This first condition is killing me! Can anyone help?
Thank you!
Bookmarks