Hi,
kindly have a look at attached XLSX file, yellow "Totals" cells.
How can I simply achieve to add up all "AAA"-related totals separately, all "BBB"related" totals separately, all "CCC"-related totals spearately, and so on, without loosing myself in uncountable IF-THEN queries?
Thanks in advance for you help.
Rgds,
sas
Try the SUMIF function
Hi
As above use the SUMIF. I have done it for you in the first one so you can see how it works.
Chris
Click my star if I helped Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks